WIP/AR Summary

The WIP/AR Summary report summarizes the unbilled WIP and unapplied progress for each client. This report helps you determine the clients that you need to bill, and includes the date when each client was last billed.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

  • Security group profile > Functional rights > Reports > Shared Library > Shared Views
  • Security group profile > Functional rights > Reports > Firm Library > Custom
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
  • Security group profile > Functional rights > Reports > Firm Library > <report name>
  • Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Reports in Foundation that are Comparable

In Practice Management, the comparable report is WIP/AR Summary. In Practice Advantage, the comparable reports are WIP Summary Aging and AR Summary Aging.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option Setting Description

Select to Include Transactions Using…

List

Determines the date type to use for the date range on the report. The options are transaction date and accounting period date.

Hide Comma

Yes/No

Includes or excludes commas in numbers.

Hide Penny

Yes/No

Includes or excludes pennies in amounts.

Default Filters
Field Name Operator Value

Date

<=

Today

Optional Filters
Available Fields

AR Balance

Client Name

Manager

Business Code

Client Office

Primary Partner

Client

Client Primary Service Type

Progress Bills

Client – Principal

Client Region

Return Group

Client Bill Manager

Client Sub ID

Tax Type

Client Billing Group

Client Type

WIP Available

Client Business Unit

Date

WIP Remaining

Client ID

Financial Reporting Client Group

 

Client ID.Sub ID

Line of Business

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields

Business Code

Client ID.Sub ID

Financial Reporting Client Group

Client

Client Name

Line of Business

Client – Principal

Client Office

Manager

Client Bill Manager

Client Primary Service Type

Primary Partner

Client Billing Group

Client Region

Return Group

Client Business Unit

Client Sub ID

Sort Name

Client ID

Client Type

Tax Type

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Available Fields

Client ID

Client Name

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field Description

Client ID

The client ID and sub-ID in Client ID.Sub-ID format.

Client Name

The client name.

WIP Available

The WIP available for billing.

Progress Bills

The total of unapplied progress bills.

WIP Remaining

The total amount of WIP available - Progress Bill amount.

AR Balance

The total AR balance for the client.

Last Invoice

The date of the last invoice for the client.

WIP/AR Summary Sample Report